class CreateTickets < ActiveRecord::Migration
  def self.up
    create_table :tickets do |t|
      t.column :title, :string, :null => false
      t.column :created_by, :integer
      t.column :updated_by, :integer
      t.column :assign_to_id, :integer
      t.column :status_id, :integer, :default => 1, :null => false
      t.column :description, :text
      t.column :created_on,      :datetime
      t.column :updated_on,      :datetime
    end
  end

  def self.down
    drop_table :tickets
  end
end
